package com.ocom.company.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ocom.common.entity.access.EntityMjDeviceInfo;
import com.ocom.common.vo.company.MjMachCountVo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface IDaoMjDeviceInfo extends BaseMapper<EntityMjDeviceInfo> {

    @Select("select  com_id as comId , count(device_no) as nowMjMachNum   " +
            "from mj_device_info " +
//			"where status = 0 " +
            "group by com_id " )
    public List<MjMachCountVo> selectMjMachCount();
}
